Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

Answers (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

You have to log in to post to discussions.

Related terms

Appsfire
Software; Phone apps

Appsfire offers free and highly discounted apps every ...

Military Cost Cutters
Software; Phone apps

This app is a must-have for military personnel and their ...

4images
Software; System software

4images is a powerful web-based image gallery management ...

GameFly
Software; Phone apps

Most gamers have heard of (and used) Gamefly, and the app ...

Satya Nadella
Software; Operating systems

Satya Nadella is the current CEO of Microsoft. He succeeded ...

Identity Protection and Access Control
Software; System software

Windows 10 helps to protect user credentials when breaches ...

Creator

Featured blossaries

Pyrenees

Category: Geography   1 14 Terms

Economics

Category: Business   2 14 Terms

Cloud Computing

Category: Technology   2 4 Terms

Mineral Water Brands

Category: Health   1 7 Terms

2014 FIFA World Cup Venues

Category: Sports   1 12 Terms

Music Genre

Category: Education   2 10 Terms

TermWiki is ranked top innovative application by IDC.

© 2024 CSOFT International, Ltd.   

Follow us on: